﻿if exists (select * from dbo.sysobjects where id = object_id(N'dbo.SourceTable') and OBJECTPROPERTY(id, N'IsTable') = 1)
drop table dbo.SourceTable

CREATE TABLE dbo.SourceTable
(
	ID int identity(1,1) CONSTRAINT PkSourceTable_ID PRIMARY KEY CLUSTERED,
	Name varchar(128) not null,
	FriendlyName varchar(128) null
	CONSTRAINT UnSourceTable_Name UNIQUE (Name)
) 